PX RECEIVE
Short Description
PX SEND and PX RECEIVE row sources represent the pipe that connects parallel execution servers which are scanning the table.
Detailed Description​
Partitioning is typically used on very large tables and use of the partition keys can allow targeted access to a reduced data set - remember - to make a query go faster - access less data. Partitioned tables can be accessed using parallel query servers. Parallel query servers are great at returning data fast, but be aware of the CPU and disk resource usage as in a multi user system, resources can be exhausted very quickly.
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.